Excel 2016: Custom & Conditional Formatting
Excel 2016: Custom & Conditional Formatting
- Customizing your number formats
- Customizing your text formats
- Customizing your date & time formats
- Creating conditional custom formats
- Using the conditional formatting tools
- Using advanced conditional formatting
- Applying color to the first new entry in a list
To customize data, you can use the built-in formats in Excel 2016, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.
Excel 2016: Custom & Conditional Formatting
Excel 2016: Custom & Conditional Formatting
- Customizing your number formats
- Customizing your text formats
- Customizing your date & time formats
- Creating conditional custom formats
- Using the conditional formatting tools
- Using advanced conditional formatting
- Applying color to the first new entry in a list
To customize data, you can use the built-in formats in Excel 2016, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.
Excel 2016: Finding, Sorting & Filtering Data
Excel 2016: Finding, Sorting & Filtering Data
- Using the Find tool
- Using the Replace tool
- Using the Find & Replace tools in a formula
- Sorting your data
- Filtering your data
- Sorting & filtering using colors
- Using slicers in tables
- Using the advanced filter options
- Hiding duplicate values
- Freezing & unfreezing panes
- Grouping items & creating an outline
Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.
Excel 2016: Finding, Sorting & Filtering Data
Excel 2016: Finding, Sorting & Filtering Data
- Using the Find tool
- Using the Replace tool
- Using the Find & Replace tools in a formula
- Sorting your data
- Filtering your data
- Sorting & filtering using colors
- Using slicers in tables
- Using the advanced filter options
- Hiding duplicate values
- Freezing & unfreezing panes
- Grouping items & creating an outline
Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.
Excel 2016: Inserting & Manipulating Data
Excel 2016: Inserting & Manipulating Data
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Using the Flash Fill feature
- Inserting dropdown menus
- Using the Spell Check tool
- Configuring Spell Check & AutoCorrect options
- Transferring data
- Copying & pasting data
- Moving data from one worksheet to another
- Transposing a data range
- Consolidating your data
Excel 2016 contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.
Excel 2016: Inserting & Manipulating Data
Excel 2016: Inserting & Manipulating Data
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Using the Flash Fill feature
- Inserting dropdown menus
- Using the Spell Check tool
- Configuring Spell Check & AutoCorrect options
- Transferring data
- Copying & pasting data
- Moving data from one worksheet to another
- Transposing a data range
- Consolidating your data
Excel 2016 contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.
Excel 2016: Referencing Data
Excel 2016: Referencing Data
- Referencing your cells
- Using data across multiple worksheets
- Choosing between absolute & relative cell references
- Naming your data ranges
- Performing calculations using constant values
- Using cell references indirectly
- Keeping an eye on your data
- Activating automatic updates
- Using formula auditing
- Understanding formula errors
Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.
Excel 2016: Referencing Data
Excel 2016: Referencing Data
- Referencing your cells
- Using data across multiple worksheets
- Choosing between absolute & relative cell references
- Naming your data ranges
- Performing calculations using constant values
- Using cell references indirectly
- Keeping an eye on your data
- Activating automatic updates
- Using formula auditing
- Understanding formula errors
Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.